<?PHP
#
# author: Cody Sorgenfrey
# (c)2012 South Hill Calvary Chapel
#

include_once("../mysql/database_info.php");
include_once("common.php");
include_once("../mysql/common.php");

$table = "events";
connect_select_test($table);
$title= "Events";
$meta_key = 'calendar, events, regular, fun, action, advent, adventure, affair, appearance, business, celebration, ceremony, chance, circumstance, deed, development, experience, exploit, function, holiday, occasion, occurrence, proceeding';
$meta_desc='Current and Regular events that occur at South Hill Calvary Chapel.';
$morehtml= null;
$morejava= null;

startPage($title, $meta_key, $meta_desc, $morehtml, $morejava);

printf("<h3>Special Events </h3>\n");

$query="SELECT * FROM $table WHERE type='S' ORDER BY start ASC";
$result=mysql_query($query) or die (mysql_error());
$num_rows=mysql_num_rows($result);
mevents_table($result,$num_rows);
printf("</div>\n\n");

printf("<div class='pageContent'>\n");
printf("<h3>Regular Events </h3>\n");

$query="SELECT * FROM $table WHERE type='R' ORDER BY start ASC";
$result=mysql_query($query) or die (mysql_error());
$num_rows=mysql_num_rows($result);
mevents_table($result,$num_rows);


mysql_close();
endPage();
?>

